Sql server has some great built-in commands procs that can help you script server or database wide commands. sp_MSForEachTable and Sp_MSForEachDb When first looking at a database , I sometimes like to run the following: execute sp_MSforEachTable @command1=‘Print ”?”; Select … Continue reading For Each … SQL System Stored Procedures